
{***********************************************************}
{                                                           }
{      Informix esql "sqlstype.h"                           }
{                                                           }
{      Translated to Object Pascal by                       }
{      Copyright (c) 2001-2008 Luxena Software Company      }
{      http://www.luxena.com                                }
{      e-mail: support@luxena.com                           }
{                                                           }
{***********************************************************}

unit IfxSqlSType;

{$I lx.inc}

interface

// SQL statement types

const

  SQ_DATABASE = 1; // DATABASE
  SQ_SELECT = 2; // SELECT
  SQ_SELINTO = 3; // SELECT INTO
  SQ_UPDATE = 4; // UPDATE...WHERE
  SQ_DELETE = 5; // DELETE...WHERE
  SQ_INSERT = 6; // INSERT
  SQ_UPDCURR = 7; // UPDATE WHERE CURRENT OF
  SQ_DELCURR = 8; // DELETE WHERE CURRENT OF
  SQ_LDINSERT = 9; // for internal use only
  SQ_LOCK = 10; // LOCK TABLE
  SQ_UNLOCK = 11; // UNLOCK TABLE
  SQ_CREADB = 12; // CREATE DATABASE
  SQ_DROPDB = 13; // DROP DATABASE
  SQ_CRETAB = 14; // CREATE TABLE
  SQ_DRPTAB = 15; // DROP TABLE
  SQ_CREIDX = 16; // CREATE INDEX
  SQ_DRPIDX = 17; // DROP INDEX
  SQ_GRANT = 18; // GRANT
  SQ_REVOKE = 19; // REVOKE
  SQ_RENTAB = 20; // RENAME TABLE
  SQ_RENCOL = 21; // RENAME COLUMN
  SQ_CREAUD = 22; // CREATE AUDIT
  SQ_STRAUD = 23; // for internal use only
  SQ_STPAUD = 24; // for internal use only
  SQ_DRPAUD = 25; // DROP AUDIT
  SQ_RECTAB = 26; // RECOVER TABLE
  SQ_CHKTAB = 27; // for internal use only
  SQ_REPTAB = 28; // for internal use only
  SQ_ALTER = 29; // ALTER TABLE
  SQ_STATS = 30; // UPDATE STATISTICS
  SQ_CLSDB = 31; // CLOSE DATABASE
  SQ_DELALL = 32; // DELETE (no WHERE)
  SQ_UPDALL = 33; // UPDATE (no WHERE)
  SQ_BEGWORK = 34; // BEGIN WORK
  SQ_COMMIT = 35; // COMMIT WORK
  SQ_ROLLBACK = 36; // ROLLBACK WORK
  SQ_SAVEPOINT = 37; // for internal use only
  SQ_STARTDB = 38; // START DATABASE
  SQ_RFORWARD = 39; // ROLLFORWARD DATABASE
  SQ_CREVIEW = 40; // CREATE VIEW
  SQ_DROPVIEW = 41; // DROP VIEW
  SQ_DEBUG = 42; // for internal use only
  SQ_CREASYN = 43; // CREATE SYNONYM
  SQ_DROPSYN = 44; // DROP SYNONYM
  SQ_CTEMP = 45; // CREATE TEMP TABLE
  SQ_WAITFOR = 46; // SET LOCK MODE
  SQ_ALTIDX = 47; // ALTER INDEX
  SQ_ISOLATE = 48; // SET ISOLATION
  SQ_SETLOG = 49; // SET LOG
  SQ_EXPLAIN = 50; // SET EXPLAIN
  SQ_SCHEMA = 51; // CREATE SCHEMA
  SQ_OPTIM = 52; // SET OPTIMIZATION
  SQ_CREPROC = 53; // CREATE PROCEDURE
  SQ_DRPPROC = 54; // DROP PROCEDURE
  SQ_CONSTRMODE = 55; // SET CONSTRAINTS
  SQ_EXECPROC = 56; // EXECUTE PROCEDURE
  SQ_DBGFILE = 57; // SET DEBUG FILE TO
  SQ_CREOPCL = 58; // CREATE OPTICAL CLUSTER
  SQ_ALTOPCL = 59; // ALTER OPTICAL CLUSTER
  SQ_DRPOPCL = 60; // DROP OPTICAL CLUSTER
  SQ_OPRESERVE = 61; // RESERVE (optical)
  SQ_OPRELEASE = 62; // RELEASE (optical)
  SQ_OPTIMEOUT = 63; // SET OPTICAL TIMEOUT
  SQ_PROCSTATS = 64; // UPDATE STATISTICS (for procedure)


  // 65 and 66 were used for SQ_GRANTGRP and SQ_REVOKGRP for KANJI
  // their functionality is replaced by ROLE


  // 67, 68 and 69 were used for SQ_SKINHIBIT, SQ_SKSHOW and SQ_SKSMALL
  // which are no longer supported


  SQ_CRETRIG = 70; // CREATE TRIGGER
  SQ_DRPTRIG = 71; // DROP TRIGGER


  // This statement type is reserved for identifying new statements with
  // custom syntax extensions to the generic SQL parser

  SQ_UNKNOWN = 72;
  SQ_SETDATASKIP = 73; // SET DATASKIP
  SQ_PDQPRIORITY = 74; // SET PDQPRIORITY
  SQ_ALTFRAG = 75; // ALTER FRAGMENT

  SQ_SETOBJMODE = 76; // SET MODE ENABLED/DISABLED/FILTERING
  SQ_START = 77; // START VIOLATIONS TABLE
  SQ_STOP = 78; // STOP VIOLATIONS TABLE

  SQ_SETMAC = 79; // SET SESSION LEVEL
  SQ_SETDAC = 80; // SET SESSION AUTHORIZATION
  SQ_SETTBLHI = 81; // SET TABLE HIGH
  SQ_SETLVEXT = 82; // SET EXTENT SIZE

{$IFDEF ROLES}
  SQ_CREATEROLE = 83; // CREATE ROLE
  SQ_DROPROLE = 84; // DROP ROLE
  SQ_SETROLE = 85; // SET ROLE
  SQ_PASSWD = 86; // SET DBPASSWORD
{$ENDIF} // ROLES

  SQ_RENDB = 87; // RENAME DATABASE

  SQ_CREADOM = 88; // CREATE DOMAIN
  SQ_DROPDOM = 89; // DROP DOMAIN

  SQ_CREANRT = 90; // CREATE NAMED ROW TYPE
  SQ_DROPNRT = 91; // DROP NAMED ROW TYPE

  SQ_CREADT = 92; // CREATE DISTINCT TYPE
  SQ_CREACT = 93; // CREATE CAST
  SQ_DROPCT = 94; // DROP CAST

  SQ_CREABT = 95; // CREATE OPAQUE TYPE
  SQ_DROPTYPE = 96; // DROP TYPE

  SQ_ALTERROUTINE = 97; // ALTER routine

  SQ_CREATEAM = 98; // CREATE ACCESS_METHOD
  SQ_DROPAM = 99; // DROP ACCESS_METHOD
  SQ_ALTERAM = 100; // ALTER ACCESS_METHOD

  SQ_CREATEOPC = 101; // CREATE OPCLASS
  SQ_DROPOPC = 102; // DROP OPCLASS

  SQ_CREACST = 103; // CREATE CONSTRUCTOR

  SQ_SETRES = 104; // SET (MEMORY/NON)_RESIDENT

  SQ_CREAGG = 105; // CREATE AGGREGATE
  SQ_DRPAGG = 106; // DROP AGGREGATE

  SQ_PLOADFILE = 107; // pload log file command
  SQ_CHKIDX = 108; // onutil check index command
  SQ_SCHEDULE = 109; // set schedule
  SQ_SETENV = 110; // "set environment ..."
  SQ_XPS_RES2 = 111; // reserved for future use
  SQ_XPS_RES3 = 112; // reserved for future use
  SQ_XPS_RES4 = 113; // reserved for future use
  SQ_XPS_RES5 = 114; // reserved for future use

  SQ_STMT_CACHE = 115; // SET STMT_CACHE

  SQ_RENIDX = 116; // RENAME INDEX

  SQ_MAXSTMT = SQ_RENIDX;


implementation

end.